Tools act_as_tree awesome_nested_set ancestry References A Nested Set Implementation in Java and PostgreSQL awesome_nested_set Ancestry http://blog.csdn.net/monkey_d_meng/article/details/6647488 http://www.sitepoint.com/hierarchical-data-database-2/